SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspProduct_UPDATE
(
@productId int = null,
@productCategoryId int = null,
@name nvarchar(128) = null,
@price money = null,
@quantity int = null,
@description nvarchar(4000) = null,
@createdDate datetime = null,
@lastModifiedDate datetime = null,
@isDeleted bit = null,
@isVisible bit = null
)
AS

UPDATE
  [dbo].[Product]
SET
  [ProductCategoryId] = @productCategoryId,
  [Name] = @name,
  [Price] = @price,
  [Quantity] = @quantity,
  [Description] = @description,
  [CreatedDate] = @createdDate,
  [LastModifiedDate] = @lastModifiedDate,
  [IsDeleted] = @isDeleted,
  [IsVisible] = @isVisible
WHERE
  [ProductId] = @productId


GO
